Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
En | 485 | 29 | 1 | 29.0000 |
però | 641 | 24 | 1 | 24.0000 |
El | 1046 | 83 | 4 | 20.7500 |
La | 836 | 82 | 4 | 20.5000 |
Per | 239 | 13 | 1 | 13.0000 |
I | 249 | 12 | 1 | 12.0000 |
Al | 87 | 10 | 1 | 10.0000 |
A | 321 | 19 | 2 | 9.5000 |
seva | 511 | 34 | 4 | 8.5000 |
Els | 371 | 24 | 3 | 8.0000 |
seu | 491 | 42 | 6 | 7.0000 |
ni | 168 | 7 | 1 | 7.0000 |
durant | 202 | 13 | 2 | 6.5000 |
les | 2443 | 205 | 32 | 6.4063 |
No | 236 | 19 | 3 | 6.3333 |
Com | 96 | 6 | 1 | 6.0000 |
d'aquest | 76 | 6 | 1 | 6.0000 |
Una | 116 | 6 | 1 | 6.0000 |
quan | 296 | 15 | 3 | 5.0000 |
sobretot | 54 | 5 | 1 | 5.0000 |
Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
mes | 62 | 1 | 8 | 0.1250 |
grans | 74 | 1 | 8 | 0.1250 |
tipus | 50 | 1 | 8 | 0.1250 |
vegades | 53 | 1 | 6 | 0.1667 |
col·lectiu | 32 | 1 | 5 | 0.2000 |
seguir | 45 | 1 | 5 | 0.2000 |
quals | 72 | 1 | 5 | 0.2000 |
moviment | 35 | 1 | 5 | 0.2000 |
sent | 53 | 1 | 5 | 0.2000 |
decidir | 39 | 1 | 5 | 0.2000 |
falta | 45 | 1 | 5 | 0.2000 |
et | 31 | 1 | 4 | 0.2500 |
cotxe | 32 | 1 | 4 | 0.2500 |
permetre | 31 | 1 | 4 | 0.2500 |
victòria | 36 | 1 | 4 | 0.2500 |
consistori | 22 | 1 | 4 | 0.2500 |
comú | 29 | 1 | 4 | 0.2500 |
nivell | 48 | 1 | 4 | 0.2500 |
mandat | 42 | 1 | 4 | 0.2500 |
quedat | 38 | 1 | 4 | 0.2500 |
In this subsection, we compute the ratio of the number of right neighbors and the number of left neighbors. Again, we look for words with extreme ratios:
Data for first table:
select word,w.freq,aa.cnt, bb.cnt,aa.cnt/bb.cnt as r from words w, (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where w_id=aa.w1_id and aa.w1_id=bb.w2_id order by r desc limit 20;
Diagram data:
select aa.cnt, bb.cnt from (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where aa.w1_id=bb.w2_id;
5.1.7.1 Number of NN co-occurrences vs. Frequency I
5.1.7.2 Number of NN co-occurrences vs. Frequency II